CREATE TABLE [dbo].[Product_Substitute]
(
[PRODUCT_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Substitute_PRODUCT_CODE] DEFAULT (''),
[SUB_PRODUCT_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Substitute_SUB_PRODUCT_CODE] DEFAULT (''),
[SUBSTITUTE_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Substitute_SUBSTITUTE_TYPE] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_Product_Substitute_SEQN] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iProduct_SubstitutePRODUCT_COD] ON [dbo].[Product_Substitute] ([PRODUCT_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_SubstituteSEQN] ON [dbo].[Product_Substitute] ([SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_SubstituteSUB_PRODUCT] ON [dbo].[Product_Substitute] ([SUB_PRODUCT_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_SubstituteSUBSTITUTE_] ON [dbo].[Product_Substitute] ([SUBSTITUTE_TYPE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Substitute] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Substitute] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Substitute] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Substitute] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Substitute] TO [IMIS]
GO